<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
#apDiv1 {
	position: absolute;
	width: 740px;
	height: 384px;
	z-index: 1;
	left: 237px;
	top: 130px;
	background-color: #CFCFCF;
}
#apDiv2 {
	position: absolute;
	width: 969px;
	height: 115px;
	z-index: 2;
	left: 8px;
	top: 6px;
	background-color: #FF3C3C;
}
#apDiv3 {
	position: absolute;
	width: 209px;
	height: 212px;
	z-index: 2;
	left: 14px;
	top: 131px;
	background-color: #CFCFCF;
}
body,td,th {
	font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
}
a:link {
	color: #2821B8;
	text-decoration: none;
}
#apDiv1 h1 {
	color: #FF3C3C;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
body {
	background-color: #838383;
}
</style>
</head>
<body>
<h1>&nbsp;</h1>
<div id="apDiv1">
  <h1>Lihat Table Pelanggan</h1>
  <table width="739" border="1">
    <tr>
      <td width="34" align="center"><strong>No</strong></td>
      <td width="103" align="center"><strong>ID</strong></td>
      <td width="170" align="center"><strong>NAMA_TOKO</strong></td>
      <td width="130" align="center"><strong>ALAMAT</strong></td>
      <td width="128" align="center"><strong>NO_TEPON</strong></td>
      <td width="134" align="center"><strong>PASSWORD</strong></td>
      <td width="134" align="center"><strong>HAPUS</strong></td>
    </tr>
    <?php
	include("Koneksi.php");
		$q = "select * from pelanggan";
		$rs = oci_parse($conn,$q);
		oci_execute($rs);
		$i=1;
	?> 
    <?php
		while($dt=oci_fetch_assoc($rs)){
		$id=$dt['ID'];
	?>
    <tr>
      <td><?php echo $i;?></td>
      <td><?php echo $dt['ID']?></td>
      <td><?php echo $dt['NAMA_TOKO']?></td>
      <td><?php echo $dt['ALAMAT']?></td>
      <td><?php echo $dt['NO_TELEPON']?></td>
      <td><?php echo $dt['PASSWORD']?></td>
      <td align="center"><a href="HapusPelanggan.php?id=<?php echo $dt['ID']; ?>">Hapus</a>
      </td>
    </tr>
    <?php
	$i++;	};
	?>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</div>
<p>&nbsp;</p>
<div id="apDiv2">
  <h1>Distributor Aqua</h1>
</div>
<div id="apDiv3">
  <table width="208" border="0">
    <tr>
      <td align="center" bgcolor="#FF3C3C"><a href="FormTerimaBarang.php">Form Terima Barang</a></td>
    </tr>
    <tr>
      <td align="center" bgcolor="#FF3C3C"><a href="FormKirimBarang.php">Form Kirim Barang</a></td>
    </tr>
    <tr>
      <td align="center" bgcolor="#FF3C3C"><a href="FormTerimaPesanan.php">Form Terima Pesanan</a></td>
    </tr>
    <tr>
      <td align="center" bgcolor="#FF3C3C"><a href="Lainnya.php">Lainnya</a></td>
    </tr>
    <tr>
      <td align="center" bgcolor="#FF3C3C"><a href="FormLogin.php">Logout</a></td>
    </tr>
  </table>
</div>
</body>
</html>
